package cn.cloud.butler.webapi.repository;

import cn.cloud.butler.webapi.domain.SystemProduceEntity;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * Created by zhouguocheng on 2018-12-21-上午 10:49
 */
public interface SystemProduceRepository extends JpaRepository<SystemProduceEntity,Integer> {

    @Query(value ="SELECT * FROM  SystemProduce WHERE MacSN = ?1",nativeQuery = true)
    List<SystemProduceEntity> SelectSystemProduce(String macsn);
}
